| hora | promedio pasajeros suben | |
|---|---|---|
| 0 | 00:00:00 | 5.454545 |
| 1 | 01:00:00 | 0.782609 |
| 2 | 02:00:00 | 1.526316 |
| 3 | 03:00:00 | 34.619048 |
| 4 | 04:00:00 | 78.940789 |
| 5 | 05:00:00 | 150.208092 |
| 6 | 06:00:00 | 172.270115 |
| 7 | 07:00:00 | 137.960227 |
| 8 | 08:00:00 | 105.516854 |
| 9 | 09:00:00 | 98.825581 |
| 10 | 10:00:00 | 92.305882 |
| 11 | 11:00:00 | 97.110465 |
| 12 | 12:00:00 | 97.658960 |
| 13 | 13:00:00 | 97.179191 |
| 14 | 14:00:00 | 105.894118 |
| 15 | 15:00:00 | 119.843931 |
| 16 | 16:00:00 | 137.429379 |
| 17 | 17:00:00 | 138.738636 |
| 18 | 18:00:00 | 115.059172 |
| 19 | 19:00:00 | 72.078313 |
| 20 | 20:00:00 | 44.592105 |
| 21 | 21:00:00 | 26.804511 |
| 22 | 22:00:00 | 13.541667 |
| 23 | 23:00:00 | 2.906977 |
| hora | promedio pasajeros bajan | |
|---|---|---|
| 0 | 00:00:00 | 1.431818 |
| 1 | 01:00:00 | 0.826087 |
| 2 | 02:00:00 | 0.315789 |
| 3 | 03:00:00 | 29.349206 |
| 4 | 04:00:00 | 67.763158 |
| 5 | 05:00:00 | 139.208092 |
| 6 | 06:00:00 | 163.839080 |
| 7 | 07:00:00 | 139.846591 |
| 8 | 08:00:00 | 108.016854 |
| 9 | 09:00:00 | 95.058140 |
| 10 | 10:00:00 | 87.794118 |
| 11 | 11:00:00 | 92.691860 |
| 12 | 12:00:00 | 91.907514 |
| 13 | 13:00:00 | 92.023121 |
| 14 | 14:00:00 | 95.517647 |
| 15 | 15:00:00 | 106.942197 |
| 16 | 16:00:00 | 120.372881 |
| 17 | 17:00:00 | 126.755682 |
| 18 | 18:00:00 | 107.869822 |
| 19 | 19:00:00 | 77.897590 |
| 20 | 20:00:00 | 52.223684 |
| 21 | 21:00:00 | 29.631579 |
| 22 | 22:00:00 | 15.566667 |
| 23 | 23:00:00 | 5.732558 |
| fecha | hora | codigoruta | cantidad | |
|---|---|---|---|---|
| 0 | 2023-03-14 | 03:00:00 | 110242 | 2 |
| 1 | 2023-03-14 | 03:00:00 | 110252 | 1 |
| 2 | 2023-03-14 | 03:00:00 | 110355 | 1 |
| 3 | 2023-03-14 | 03:00:00 | 110425 | 2 |
| 4 | 2023-03-14 | 03:00:00 | 110615 | 5 |
| ... | ... | ... | ... | ... |
| 22822 | 2023-08-30 | 23:00:00 | 110742 | 1 |
| 22823 | 2023-08-30 | 23:00:00 | 110752 | 1 |
| 22824 | 2023-08-31 | 00:00:00 | 110782 | 1 |
| 22825 | 2023-08-31 | 00:00:00 | 111415 | 1 |
| 22826 | 2023-08-31 | 00:00:00 | 120692 | 1 |
22827 rows × 4 columns
| hora | velocidad promedio | |
|---|---|---|
| 0 | 00:00:00 | 2.005690 |
| 1 | 01:00:00 | 0.393921 |
| 2 | 02:00:00 | 0.014530 |
| 3 | 03:00:00 | 9.489936 |
| 4 | 04:00:00 | 10.740703 |
| 5 | 05:00:00 | 9.460708 |
| 6 | 06:00:00 | 8.277617 |
| 7 | 07:00:00 | 7.822308 |
| 8 | 08:00:00 | 7.530643 |
| 9 | 09:00:00 | 7.414085 |
| 10 | 10:00:00 | 7.179747 |
| 11 | 11:00:00 | 7.136564 |
| 12 | 12:00:00 | 7.204948 |
| 13 | 13:00:00 | 7.135577 |
| 14 | 14:00:00 | 7.050081 |
| 15 | 15:00:00 | 6.625561 |
| 16 | 16:00:00 | 6.402883 |
| 17 | 17:00:00 | 6.437497 |
| 18 | 18:00:00 | 6.973490 |
| 19 | 19:00:00 | 7.833711 |
| 20 | 20:00:00 | 8.729982 |
| 21 | 21:00:00 | 8.766529 |
| 22 | 22:00:00 | 8.595890 |
| 23 | 23:00:00 | 6.225116 |